﻿package com.fandy.struts.SqlStatement;

public class Response {
 
	public   String  getAll()
	{
		return   "select * from Response";
	}
	
	public   String getInfoByID(int ID)
	{
		return  "select * from Response where " +com.fandy.struts.Meta.Response.getClientid()+"="+ID;
	}
	
	
	public String Add(com.fandy.struts.Model.Response r)
	{
		
		return "insert into Response values ("
		+ "'" + r.getClientid()+"',"		 
		+ "'" + r.getClientname()+"',"
		+ "'"  + r.getGoodsname() + "',"
		+ "'"  + r.getImage()+ "',"
		+ "'"  + r.getMessage()+ "',"
		+ "'"  + r.getRemsg()+ "',"
		+ "'"  + r.getSatisfactory() + "',"
		+ "'"  + r.getDate() + "',"
		+ "'"  + r.getTheme() + "',"			
		+")"
		;
		
	}
	
	
	
//	public String UpdateByID(int id,com.fandy.struts.Model.Response s)
//	{
//		
//		return "update GoodsInfo set "+com.fandy.struts.Meta.Response.getClientid()
//		+"='" + s.getClientid()+"',"		 
//		+com.fandy.struts.Meta.Response.getClientname()+"='" +s.getClientname()+"',"
//		+com.fandy.struts.Meta.Response.getDate()+ "='"  + s.getDate() + "',"
//		+com.fandy.struts.Meta.Response.getGoodsname()+ "='"  + s.getGoodsname() + "',"
//		+com.fandy.struts.Meta.Response.getImage() + "='"  + s.getImage() + "',"
//		+com.fandy.struts.Meta.Response.getMessage()() + "='"  + s.getMessage() + "',"
//		+com.fandy.struts.Meta.Response.getRemsg() + "='"  + s.getRemsg()+ "'"
//		+com.fandy.struts.Meta.Response.getRemsg() + "='"  + s.getRemsg()+ "'"
//		+com.fandy.struts.Meta.Response.getRemsg() + "='"  + s.getRemsg()+ "'"
//		+"where "+com.fandy.struts.Meta.Response.getResponseid()+"="+id;
//		
//	}
	
	
//	public String DeleteByID(int id)
//	{
//		
//		return "delete from Response where " + com.fandy.struts.Meta.Response.get() +"="+id;
//		
//	}
	
	
	
}

